create procedure [dbo].[BAEOrderProductInsert] @Title as
varchar(128),
    @Description AS varchar(1024),
    @IsSuperProduct AS bit,
    @ProductCode AS varchar(64),
    @SellOnWeb AS int
AS
    INSERT INTO OrderProduct
    (    
    Title,            
    Description,            
    IsSuperProduct,                
    ProductCode,            
    SellOnWeb        
    )
    VALUES
    (    
    @Title,            
    @Description,            
    @IsSuperProduct,                
    @ProductCode,            
    @SellOnWeb                                                                    
    );

    SELECT CAST(@@IDENTITY AS int) AS 'InsertedOrderProduct';

GO